Skip Headers

Oracle® interMedia User's Guide 10g Release 2 (10.2) Part Number B14302-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# B Installing and Upgrading Oracle interMedia

This appendix describes the manual installation of Oracle interMedia ("interMedia") (see Section B.1) as well as the manual upgrading of an installed version of Oracle interMedia (see Section B.2).

Note: See the interMedia `README.txt` file located in `<ORACLE_HOME>``/ord/im/admin` for the latest information.

## B.1 Installing Oracle interMedia

Oracle interMedia is installed and configured with Oracle Database. If, for some reason, you need to install interMedia manually, you can follow the instructions in this section, according to the following topics:

- Installation decisions

- Preinstallation steps

- Installation steps

### B.1.1 Installation Decisions

The installation procedure creates the `ORDSYS`, `ORDPLUGINS`, `SI_INFORMTN_SCHEMA`, and `MDSYS` users. These user IDs are the standard Oracle Database account with special privileges.

Decision: Decide which tablespace to use for interMedia users (`ORDSYS`, `ORDPLUGINS`, and `SI_INFORMTN_SCHEMA`), and which tablespace to use for the Spatial/interMedia Location Services user (`MDSYS`). Oracle suggests you use the SYSAUX tablespace for both.

Decision: Decide on passwords for the `ORDSYS`, `ORDPLUGINS`, `SI_INFORMTN_SCHEMA`, and `MDSYS` users. The installation uses default passwords for `ORDSYS`, `ORDPLUGINS`, `SI_INFORMTN_SCHEMA`, and `MDSYS`. Then, it locks the accounts and expires the passwords. You must change these passwords and unlock the accounts after the installation completes if you want to log in to these accounts directly.

The default password for the `ORDSYS` user during automatic installation is `ORDSYS`, for `ORDPLUGINS` is `ORDPLUGINS`, for `SI_INFORMTN_SCHEMA` is `SI_INFORMTN_SCHEMA`, and for `MDSYS` is `MDSYS`.

The installation process grants the EXECUTE privilege to the user group PUBLIC for the interMedia packages and objects installed in the `ORDSYS`, `ORDPLUGINS`, and `SI_INFORMTN_SCHEMA` schemas.

### B.1.2 Preinstallation Steps

Perform the following preinstallation tasks prior to manually installing and configuring interMedia. For instructions, see Oracle Installation Guide for your operating system:

1. Install Oracle Database, including PL/SQL, Oracle JVM, and Oracle XML DB.

2. Create the database.

3. Start the database.

4. Verify that Oracle JVM is installed and is valid.

   You can verify that Oracle JVM is correctly installed by running SQL*Plus, connecting as SYSDBA, and issuing the following query:

       SQL> select version, status from dba_registry where comp_id='JAVAVM';

   Ensure that the version is correct and the status is `VALID`.

### B.1.3 Installation Steps

Perform the following mandatory configuration steps. Remember, you need to do this only if you are configuring interMedia manually. You do not need to do this if you use the Database Configuration Assistant.

References to `<ORACLE_HOME>` in these instructions represent the Oracle home directory.

1. Use Oracle Universal Installer to install the files that make up interMedia on your system.

2. Create the users and grant the appropriate privileges.

       Start SQL*Plus.

       % sqlplus

       Connect as SYSDBA.

       SQL> connect / as SYSDBA

       Invoke ordinst.sql with two parameters for interMedia tablespace and
       Location Services tablespace.

       SQL> @<ORACLE_HOME>/ord/admin/ordinst.sql SYSAUX SYSAUX (on UNIX)
            @<ORACLE_HOME>\ord\admin\ordinst.sql SYSAUX SYSAUX (on Windows)

3. Install interMedia types and packages.

       SQL> @<ORACLE_HOME>/ord/im/admin/iminst.sql (on UNIX)
            @<ORACLE_HOME>\ord\im\admin\iminst.sql (on Windows)

4. Start the listener.

   The listener must be configured to use external procedure calls. Check your `tnsnames.ora` file for an entry called `extproc_connection_data` and in the `listener.ora` file for an entry called `extproc`.

   See your network documentation for details. If this is not done properly, interMedia will not work for all supported formats.

Once these mandatory installation steps have been completed, interMedia is ready for use.

## B.2 Upgrading an Installed Version of Oracle interMedia

If you upgrade a database from an earlier release of Oracle Database, interMedia will be upgraded automatically if detected in the source database. See Oracle Database Upgrade Guide for detailed instructions.

## B.3 Verifying an Installed Version of Oracle interMedia

After installing or upgrading interMedia, you can verify the interMedia installation by invoking the interMedia check script.

To run the interMedia check script, connect as SYSDBA and invoke `imchk.sql` as follows:

1. Start SQL*Plus.

       % sqlplus

2. Connect as SYSDBA.

       SQL> connect / as SYSDBA

3. Invoke `imchk.sql`.

       On UNIX
       SQL> @<ORACLE_HOME>/ord/im/admin/imchk.sql

       On Windows
       SQL> @<ORACLE_HOME>\ord\im/admin\imchk.sql

The check script will produce the list of interMedia components and their status values, and a summary line indicating whether or not the interMedia installation is valid. All interMedia components are expected to have the status `VALID`.

## B.4 Downgrading an Installed Version of Oracle interMedia

Oracle interMedia is automatically downgraded when you downgrade a database with the interMedia feature installed. See Oracle Database Upgrade Guide for detailed instructions.